Part II - Study of USA flights in 2007¶

by Ouedraogo Ami Samyra¶

</div>

Investigation Overview¶

Over price,confort and security many reason motivate people to choose a specific airlines for their trip. The competition and the mean of taking a plane which is supposed to be on time is extremely important. In fact airlines can't effort to be listed in as most likely to be delayed flight. For those reasons,they have to manage and minimize as much as possible causes of flight delays or flight cancelled.

My main objective is to share important information with the public so that they can know the conditions of cancellation or delay of a flight.

Dataset Overview¶

The data consists of flight arrival and departure details for all commercial flights within the USA, from October 1987 to April 2008. This is a large dataset: there are nearly 120 million records in total, and takes up 1.6 gigabytes of space compressed and 12 gigabytes when uncompressed. We are studying flight over 2007 , the dataset contains 7453188 fligts records shared in 31 features from 291 differents departures place to 293 destinations in 2007 !

(Visualization 1)¶

At what time of the year is it more likely to be cancelled?¶

In 2007, we noticed more flights canncelled in February and December and less flights cancelled in september and November. Generaly your flight has more chance to be cancelled in December and March than between September and November.

(Visualization 2)¶

What were the main reasons of cancelled flight per Airlines ?¶

MQ, AA and OO for American Eagle Airlines Inc, respectively American Airlines Inc. and Skywest Airlines Inc ,have the highest number of cancelled flights in 2007 and these airlines also have the highest number of cancellation codes in the national airspace system (non-extreme weather conditions, airport operations, high traffic volume, air traffic control, etc.). In fact, the main reasons for flight cancellation are either the carrier itself or the weather.

(Visualization 3)¶

Which carriers delays in 2007 registered the most flight delays ?¶

The red list of carriers that we should considered when travelling is

  • 'EV': 'Atlantic Southeast Airlines',
  • 'B6': 'JetBlue Airways',
  • 'AA':'American Airlines Inc.',
  • 'UA': 'United Airlines',
  • 'MQ': 'American Eagle Airlines Inc.'

(Visualization 4)¶

At what time of the year do we observed more flight delays top 5 busiest carriers ?¶

Over 2007 Considering the top five airlines that register more delays ,I can here see that those airlines have registered the most high delay in the period from May to August ,which is considerd as the summer season ,we can surmised that it might have more passengers to handle this periods because it is holidays period for student so the Airlines might have to deals with differents situations